(SELECT
/* 1-2-3 */
BI0HWBS_ELEMT3.NODENAME,
BI0HWBS_ELEMT3.tlevel,
BI0HWBS_ELEMT1.NODENAME,
  BI0HWBS_ELEMT2.NODENAME,
  BI0HWBS_ELEMT3.NODENAME,
    '','',''
FROM
  BI0HWBS_ELEMT  BI0HWBS_ELEMT1,
  BI0HWBS_ELEMT  BI0HWBS_ELEMT2,
  BI0HWBS_ELEMT  BI0HWBS_ELEMT3
where
 (  ( BI0HWBS_ELEMT3.TLEVEL='03'  )
  AND  ( BI0HWBS_ELEMT2.TLEVEL='02'  )
  AND  ( BI0HWBS_ELEMT1.TLEVEL='01'  )
  AND  ( BI0HWBS_ELEMT1.NODEID=BI0HWBS_ELEMT2.PARENTID  )
  AND  ( BI0HWBS_ELEMT3.PARENTID=BI0HWBS_ELEMT2.NODEID  ))
)
union

(SELECT
/* 1-2 */
BI0HWBS_ELEMT2.NODENAME,
BI0HWBS_ELEMT2.tlevel,
  BI0HWBS_ELEMT1.NODENAME,
  BI0HWBS_ELEMT2.NODENAME,'','','',''
FROM
  BI0HWBS_ELEMT  BI0HWBS_ELEMT1,
  BI0HWBS_ELEMT  BI0HWBS_ELEMT2
where
( BI0HWBS_ELEMT2.TLEVEL='02'  )
  AND  ( BI0HWBS_ELEMT1.TLEVEL='01'  )
  AND  ( BI0HWBS_ELEMT1.NODEID=BI0HWBS_ELEMT2.PARENTID  )
)
